/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : users

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 28/06/2021 13:59:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for role_info
-- ----------------------------
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
  `r_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`r_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_info
-- ----------------------------
BEGIN;
INSERT INTO `role_info` VALUES (1, '超级管理员', '系统最高级用户！');
INSERT INTO `role_info` VALUES (2, '用户', '普通用户');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) NOT NULL,
  `user_password` varchar(50) NOT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` bit(1) DEFAULT NULL,
  `tel` char(11) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `break_count` int(11) DEFAULT 0,
  `u_status` bit(1) DEFAULT b'0' , -- 黑名单(1)、白名单(0)
  PRIMARY KEY (`u_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info`(u_id,user_name,user_password,age,sex,tel,email,role_id) VALUES (1, 'admin', '123456', 18, 1 , '13543063056', '3147083@qq.com', 1);
INSERT INTO `user_info`(u_id,user_name,user_password,age,sex,tel,email,role_id)  VALUES (2, '王亮', '123456', 25, 0 , '13543063056', '3147083@qq.com', 2);
INSERT INTO `user_info`(u_id,user_name,user_password,age,sex,tel,email,role_id)  VALUES (3, '张乾新', '123456', 25, 0 , '13417747371', '114729040@qq.com', 2);
INSERT INTO `user_info`(u_id,user_name,user_password,age,sex,tel,email,role_id)  VALUES (4, '王亮', '123456', 37, 1 , '11011011011', '11011011011@qq.com', 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
